You are here: Main Menu > 1. Sales Menu > R. Reports > D. Items by Customer Report

Items by Customer Report

The Item by Customer Report option provides a 13-month perspective of:

 

All customers are listed along with the items they purchased in customer code sequence followed by item code sequence.

There is also an Items by Customer Weekly Report which reports the pounds shipped by day of the week and a Customer by Item report which lists the same information for each item and customer purchase.

Available Actions Using Printing

 

Items By Customer Report Fields
Report Date The date for the report.
Item Mask The item maskCollapsed for the report.
(B)ill To or (S)hip To

Enter B (B=customer bill-to address) to run the report based on the bill-to address or enter S (S=customer ship-to address) to run the report for the customer ship-to address.

Customer Mask

Enter the customer ID code, the customer maskCollapsed for the report or enter "//////" to run the report for all customers.  
Sales Rep The sales rep(s) for the report. Select one, several, or all sales reps.
Broker The broker(s) for the report. Select one, several, or all brokers.
Totals Only (Y/N) Enter Y (Y=yes) to show totals by customer only; enter N (N=no) to include the detail of all items sold to the customer.
Display

Select the display option:

  • Prod Dollars – Total product sales dollars
  • Gross Profit – Gross profit dollars
  • Gross Margin % – Gross profit percentage
  • Pounds – Pounds invoiced
  • Eaches – Eaches invoiced.

 

Security Required : Sales - Sales Reports

See Also